SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566941 LIMIT 1 [ RunTime:0.001574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566941 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433557,189420,176136,229920,389717,423489,439734,459775,820762,540794,668873,1011573,822308,339634,964873,253153,107339,51270,1027637,837283,25439,1024913,601890,153683,471684,1001207,993669,657320,145457,669057,997178,615127,172727,796270,226536,126930,298755,376005,58250,298818,184732,511079,778174,625329,813529,589992,834740,479694,276713,152968,869685,685964,685967,612845,747647,941590,767937,264901,108797,434243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001729s ]