SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314139 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314139 [ RunTime:0.002817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718266,481818,416109,790528,461837,689780,468080,597986,164293,266209,1045302,533379,1032720,185539,555278,836797,190981,889714,336,457058,203456,760921,182908,38652,453644,200580,467699,460550,449152,737793,862485,253964,736503,1012468,591507,817213,761264,1024379,720711,531899,486427,323387,127004,457828,897786,583251,198918,574057,627179,216782,447190,319458,344838,286632,1037469,804666,934402,932522,258894,467241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]