SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 57510 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 57510 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354155,449611,719356,1047848,132861,1025755,129611,35157,798021,1043543,885378,1026485,101440,345846,306360,296195,951154,411775,343738,475534,145598,410818,340816,751862,35928,817181,919529,393104,415013,637396,272916,877677,886674,944303,835499,273267,817953,680750,445113,1022313,846380,27094,614223,724474,301236,865878,381426,230340,685145,138953,177318,410712,26594,301378,846330,845239,90893,759250,311786,125533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 57510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 57510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000792s ]