SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546913 LIMIT 1 [ RunTime:0.000732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546913 [ RunTime:0.004025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729578,62805,515656,885129,608509,406191,553324,898490,199281,535379,1000489,697574,357897,878272,602598,531457,524789,700995,657014,544025,628176,204903,482596,938990,622939,83751,87117,430246,32217,232634,1003712,234869,249107,928685,627186,608809,988758,881795,440659,899549,973723,499976,336910,10836,444769,1025559,452380,466119,204673,826663,229156,91190,23237,384560,689446,36683,265101,261770,583197,1040431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001546s ]