SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642014 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642014 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473521,939539,336610,683761,773385,430902,851091,400133,318608,180346,6016,64060,209139,239540,349950,1020716,686412,557607,225056,451399,531407,724117,116365,970990,485419,1026304,611418,252258,729344,637328,113786,715635,300510,598784,512044,645211,474845,428354,451873,802861,477845,431299,32606,639387,323178,548324,474363,847954,819011,393303,94868,906663,685981,272045,924359,486986,732540,740859,18438,671466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]