SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023011 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023011 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419996,647476,310553,595391,971015,877326,567905,138322,548152,445823,205462,316397,140388,709958,997295,197922,856323,593603,514870,694847,1009060,771481,375898,10595,668227,633193,400513,223372,1034139,576707,1009807,215245,1033017,365479,694227,355725,907921,756020,992824,571820,357284,817724,1021918,870125,608577,100409,528410,143071,501110,686523,35087,389118,236688,929882,129469,882455,185155,227861,180603,177031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000819s ]