SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429913 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429913 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196623,929935,188464,772654,871519,204456,297152,593558,664177,797654,339601,999028,330966,23054,40102,953414,958545,119587,325706,89115,210675,388337,28790,334841,754808,450981,972419,814600,227095,516683,879910,499074,442796,929801,860021,787848,263499,786478,996993,111715,891561,750143,673499,705356,561035,540913,565226,326175,668370,430451,75554,85105,251887,168950,169501,897773,583317,508836,130398,914421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]