SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406861 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406861 [ RunTime:0.004625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181664,618496,143805,118465,756047,447497,370128,957637,234367,854649,232750,744838,26492,387262,719530,281818,633745,699429,325912,353602,955565,375756,187211,905353,235250,846348,479401,161828,70923,97524,362328,356278,1043162,606800,961330,706553,739925,952719,799892,1038676,675455,214298,600983,959197,89388,651400,192861,788500,373835,59982,78431,278254,388941,263492,667948,948192,909452,862388,321177,98533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]