SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34981 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34981 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714135,604874,617686,84595,768501,282737,242550,586194,250603,4282,715175,763185,481775,848753,641992,711298,139705,476450,166716,284449,1002063,937440,638405,841011,261805,139674,503880,431886,113563,790164,106347,208907,503438,721626,729738,898259,220669,820577,513436,433313,1004633,194730,737331,705390,863896,780866,749054,167465,498034,808914,381912,109080,650460,1031313,644148,899572,393670,383963,178754,329817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]