SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531958 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531958 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785934,584891,310724,699763,1043663,860768,744728,818811,989723,860276,1007520,376381,581061,791092,28145,510539,99274,959223,383829,444797,496696,276416,181253,16568,695797,201486,531945,608726,206225,845743,687156,97932,463816,96455,720287,573448,239323,365886,936311,59384,280399,186481,874833,725273,803486,348494,428582,235651,472084,713087,745078,863201,503660,28922,56919,16057,1018212,564975,827887,3063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]