SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338618 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338618 [ RunTime:0.004051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720042,796990,689058,635289,410624,516499,110558,443455,490692,281519,162638,29678,394610,505149,1037987,465766,565336,753585,972292,888442,754340,111873,665539,845512,967608,532439,696484,272763,57433,755991,174271,527864,231303,855577,531212,163453,1047416,496539,207497,332285,635255,297110,127476,990770,898983,633709,766000,103373,356618,623855,330056,708278,789661,678156,696831,1016439,957726,147027,751680,698066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002223s ]