SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343513 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343513 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519999,1019257,81521,434330,219743,716106,740719,575124,994080,129340,837836,602844,79434,509344,487643,202605,1005629,96730,635034,104862,1036516,413934,216459,238985,739704,47493,441868,856200,53798,228679,526735,868012,758260,175940,693079,325364,1023704,303198,181725,387718,323272,65675,2294,435275,21746,491921,411348,835469,709790,513734,809341,793993,807441,6777,133863,580678,66180,618865,230414,249848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]