SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028672 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028672 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637343,930274,647110,689109,28390,79280,897646,367113,606652,335499,658931,1019211,107437,795602,212951,504287,436458,20419,739215,357177,815377,693879,753570,869499,619807,201606,757515,716192,1002520,427921,527861,705825,465838,385465,316143,784604,607279,5327,372353,571102,296391,533496,989141,647296,912170,80613,196635,417631,613601,164276,514804,789758,815928,902206,644628,853875,786570,613169,984700,256164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]