SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404472 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404472 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413480,499879,926605,344405,1006480,358107,592436,433672,875613,782094,419035,800890,1042784,22293,769937,51579,232212,219757,1044523,450199,607780,1013375,640282,32261,492750,50241,822492,780387,170415,964436,99808,659943,765254,208649,850961,829460,584614,239366,391709,939019,939859,294421,269937,510131,232379,110706,847469,268258,239827,12350,962381,548093,155126,795962,948752,26645,155282,72879,987462,912057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404472 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404472 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]