SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80291 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80291 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338827,820377,109537,577176,1013380,475679,934477,729681,177170,226423,24623,986548,1018405,748762,981661,137371,259238,437258,840673,311525,175694,227391,916159,234292,22942,97243,614613,73636,151648,766020,874325,776394,831328,573378,18134,311835,803566,115608,137750,129380,43276,698395,479479,1002577,900250,236527,132145,1028913,216351,668233,856936,815185,749301,803360,101345,648435,269978,562638,587928,767397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]