SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268207 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268207 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76807,991439,18909,497401,38561,138543,413301,68616,379326,121472,56730,669500,354363,158774,10415,975389,337990,364994,724805,145838,80143,125460,585207,914971,933321,914755,235336,678340,439509,49107,689077,972369,188760,219290,173327,253506,863852,472447,683438,362828,366590,792991,316368,518852,171155,978146,855439,64778,526054,953787,807145,670604,747123,463494,690693,175680,604663,929025,805187,248277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]