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` = 534081 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534081 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111084,800439,434407,816758,956247,432563,719267,268372,406606,145058,804128,451168,190593,743999,834115,68887,236959,675003,1026097,811664,114378,420026,149683,405740,947187,61202,988203,506398,606566,687208,146396,493217,928576,91801,954790,464657,448706,434372,584060,200447,77580,721515,202622,935349,24523,169433,838108,152543,137483,171789,285236,1028090,327409,520783,806730,890972,109831,107893,962084,628322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]