SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293658 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293658 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527668,375789,672043,609008,602726,912616,792584,23286,472171,489697,182599,117959,445713,931405,202210,320871,335494,119551,161069,408305,105972,77901,595595,949373,367395,851146,621041,606611,57682,118041,226865,820170,297082,31154,468196,435584,478021,246009,362508,317396,242762,28950,527750,132927,762873,599463,384172,759275,948827,649763,240393,564473,878023,790202,973339,581322,337888,241827,775850,534952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]