SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012495 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012495 [ RunTime:0.005500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339364,772532,236588,747756,928120,349071,975998,59037,8340,844510,747902,826867,695123,44456,836367,648116,985066,810718,81085,571823,819237,974533,890699,842417,112891,244291,25757,573119,689021,762396,1029140,585421,357336,156178,602152,1023433,41055,1004404,914669,199942,813028,453640,139994,975563,435209,947135,255337,507768,38763,731711,239553,638940,267244,565639,14842,181970,624895,85166,545756,722400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]