SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 236980 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 236980 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809803,104270,326544,606454,366868,355106,456928,300177,637370,57806,480965,332599,195690,186370,27551,449672,1034818,655167,340449,837585,841868,714348,840753,888885,135524,35991,713282,495011,506796,201918,946755,131451,35741,57485,125153,22632,362900,40558,775205,319395,112732,942823,469768,24390,424037,412264,564899,845615,231601,908090,913243,798808,111620,801575,535041,534517,712349,272923,468956,220223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 236980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 236980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]