SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533050 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533050 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338101,440485,221599,29201,301851,860763,362717,31221,275277,722412,132462,782323,625392,744414,872352,576677,380790,592309,568078,688740,601841,737270,432201,295238,297638,1024186,26592,662943,788860,483524,1005161,576340,290724,444124,403638,279534,282491,125854,241130,280923,309023,186083,431370,271374,904875,35380,449954,28178,280882,229206,464009,766403,859393,146010,113876,179273,1023577,155790,5654,844499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]