SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440120 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440120 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684014,210843,110044,106532,307859,72897,346898,704017,138073,803040,2328,181001,497406,345484,341869,536987,661837,1016455,706144,225114,787194,68764,322617,254727,951233,533639,769745,1008512,508634,896424,163863,813581,559098,107747,944304,930626,464307,27382,862393,1004891,197616,593469,875365,1044637,431231,132342,365028,878003,241307,828001,736069,873841,731558,145040,609810,322318,525351,586062,409046,193514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]