SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319942 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319942 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511109,1024118,551873,658250,261139,840190,560702,825114,761328,825873,510253,479128,487724,853463,823238,91046,275725,733276,424199,395659,467628,550041,248370,969696,573853,871828,305251,348608,58824,456650,692955,845078,165807,507722,948206,988552,96424,228637,475733,942635,861258,160173,624355,1009443,443912,759968,498793,834277,226963,458153,566099,334867,913440,849902,241548,465387,589532,204762,334674,288684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]