SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545640 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545640 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264959,679118,105587,71311,255796,347907,274812,1016362,761803,571625,362640,94222,894309,658008,116792,1016134,502571,114389,591794,280057,458955,207884,280225,375716,749873,452674,495898,692482,925039,434600,503754,356089,132109,533391,333475,431056,949249,247018,308167,625425,675174,432817,750782,307339,847028,267716,456996,183928,606794,314808,83746,408816,111533,647600,553254,616952,124645,688264,584127,134532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]