SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 998610 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 998610 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354315,810362,13253,392949,1016867,248667,570989,699983,362803,832109,391897,835614,894396,256440,785457,515407,852734,971386,881050,664174,960362,409040,715157,722569,60264,9607,277003,988591,489405,746422,322120,16078,490669,929842,412630,413072,365445,249363,159669,843697,977950,366389,20680,108438,841574,954845,5575,991245,367438,119263,1002558,5803,87928,791359,229853,638499,836986,873355,292057,747331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 998610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 998610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]