SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2483 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2483 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531073,453520,829808,1040093,325625,546634,888001,128131,285256,844501,440904,38236,947877,527968,951733,281018,216113,838013,797952,62715,155716,759262,76343,1005974,783800,109027,614522,517898,311859,150105,431150,758374,938861,443921,963551,824590,629704,848760,904323,51986,796032,173929,973087,1042756,183225,527181,823041,872759,88911,456759,384448,850581,910363,674099,801502,73663,771026,765220,305763,63446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]