SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578983 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578983 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773845,357703,168587,691063,362977,446360,300755,1020735,589528,811892,1033267,282614,481607,28512,317862,371147,21081,396031,190427,697466,452436,958302,270899,27832,895187,514154,914899,694923,980352,1031827,7827,669441,551006,861724,118778,363363,180628,113063,404258,544164,442350,112125,132959,902272,924260,429915,176367,495838,175002,898792,949036,669740,355936,101023,708400,845922,158681,707790,305415,53295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]