SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407430 LIMIT 1 [ RunTime:0.000695s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407430 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899617,179300,567571,129235,688650,316923,719275,588508,692543,186182,392945,506869,399093,118725,164961,135234,928321,535560,819061,1042686,941819,304080,928700,276494,621946,619347,1023572,1020275,663569,754391,982525,196301,191382,997403,802090,123724,371847,657450,843639,450069,77988,615541,509732,1035406,700098,83643,88861,106023,317576,769840,928685,643459,847404,262227,596482,477849,277530,678482,1032493,563274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]