SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536140 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536140 [ RunTime:0.002789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959171,339112,203399,320810,802104,593720,624570,524313,948645,467004,552747,908922,357146,845383,711149,992466,163632,368200,371024,783997,519689,1022943,527588,977983,933606,572256,359023,828818,86553,613110,876918,612872,871080,633318,301699,480831,20349,231534,754920,249255,97149,717350,148061,876799,574413,60950,749407,638554,55546,879249,870176,288046,460083,246288,600140,893934,906666,649407,94229,430654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]