SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031176 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031176 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431551,76572,473322,792188,1014564,163252,511710,117826,119525,399401,718550,12476,311490,246612,534476,101774,556759,840301,716285,35225,554222,536438,72906,41232,682410,922998,736813,522524,346946,370330,959733,124490,566177,269887,369807,1028777,13858,910529,574009,240346,641141,358889,655453,182075,234816,359958,335057,542015,452011,412037,353229,540473,211367,231772,252947,109281,378188,957318,753449,912631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]