SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583190 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583190 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827701,331060,1046560,683341,1024808,338791,772358,665841,797062,710723,242420,264376,825095,48092,223165,61825,521922,362844,378447,1000715,441868,382304,1002002,579929,888312,329411,598418,281778,670159,931516,936916,858869,196391,252897,179928,656668,739730,734951,186692,540093,491580,185499,598686,972119,135433,1048802,738153,628242,941560,490513,991985,1031446,789556,296705,175438,864584,706276,432790,1027853,274854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]