SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981583 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981583 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843747,424812,785140,185169,448746,965376,181786,414723,611265,923414,748802,370505,988961,279296,894995,559095,979289,834025,598799,1042649,447431,141140,1035396,515005,125963,393742,163980,282894,17699,916486,75241,791347,592836,972391,187099,41952,946564,1001918,888970,852341,998433,191988,41871,628776,361927,1041852,118933,106353,895938,628341,476622,710546,715358,16281,663917,240368,265443,480806,1008299,516778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]