SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040022 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040022 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256230,751008,982442,370769,1047146,216225,332481,284182,579458,605863,752219,383294,15074,322826,1045115,26095,267665,25302,423007,991393,722162,540883,541423,194729,286355,410355,51187,881955,88299,987780,121411,377860,889023,225999,810973,362377,786031,427704,766380,476591,402042,31569,563692,1013099,895559,297943,988681,122258,224367,457063,82566,910218,842005,893339,673757,577972,702994,891676,1042572,120359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]