SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002865s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027452 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027452 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957012,188173,483037,31871,105556,591210,684259,1015337,976518,242837,232483,185978,829911,129708,641929,219306,312561,608779,9880,792593,219420,116989,229694,582275,578640,482692,319853,463536,214005,340222,913197,32559,624063,830103,572889,674804,337266,528533,309452,520755,21092,985642,698737,22304,223680,1043856,561587,69467,266020,12066,145527,365791,466066,370055,1025157,658350,596992,1006464,333244,392413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]