SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028003 LIMIT 1 [ RunTime:0.001186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028003 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72591,191675,350113,505737,796748,620605,122465,134823,23729,185126,653163,626923,99442,556120,508121,419428,614495,649688,580528,355068,250173,591395,714038,122475,936417,829796,132335,1015265,330671,403789,13389,263363,994893,407895,1042689,461525,714478,485103,949610,176012,16219,289529,371093,144961,960789,245742,202718,801709,590755,748743,450853,886155,137072,37650,668595,995854,431730,773095,23410,500587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001006s ]