SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542631 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542631 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736179,292811,838700,570585,209131,395449,274466,314826,949286,401642,684625,194595,626650,43498,167632,1041651,743900,648884,176026,817743,25830,913873,440489,775041,244949,879862,913618,860522,769725,172857,225614,468916,87074,76781,670344,806027,905189,337765,719313,195895,910972,1012237,449385,800001,515184,691514,256321,42851,1023852,1032570,694362,465843,893365,1010378,584293,737645,436304,120867,994477,571343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000894s ]