SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583344 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583344 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044923,369727,854317,468117,468131,818190,128098,735123,865927,800819,359004,901588,623212,348512,535737,376398,963398,652046,1032258,103475,33006,942529,372370,308357,220380,299677,7625,649129,1015113,456257,220886,565906,15917,596665,155943,626117,781340,470776,289841,26754,899921,570164,179896,226654,130137,251877,14499,198686,240379,43581,918833,833925,147353,232468,493795,909044,857756,225256,330777,841420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009804s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004844s ]