SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342903 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342903 [ RunTime:0.003609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588029,196937,757796,702275,411789,761424,826762,673614,468883,244147,918813,308859,290365,916106,262965,249426,774339,319183,754902,1630,58790,749942,884294,812549,552532,98300,1030176,420594,511174,912479,446328,348041,505339,269508,73106,693065,686879,126941,1034422,890146,860196,209394,564367,186472,341018,602116,772194,641380,439011,86244,356037,227906,717535,19042,169161,20860,572111,955756,772254,670603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]