SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035842 LIMIT 1 [ RunTime:0.001607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035842 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020178,340334,55324,334542,415084,327108,66481,677249,10068,446274,851987,520730,744332,879919,710683,111115,824010,765195,133534,659629,985084,80734,343362,503697,921832,299014,588246,438037,194413,1000077,308990,826530,247087,790956,885763,802899,20118,612546,716792,648665,495259,252874,238769,133901,207854,456009,546456,212587,533362,822192,1018820,113046,574804,1025745,851122,109080,321930,994401,662519,209285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]