SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492081 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492081 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150525,609364,161424,86906,886963,339826,916956,394668,1032819,106644,391337,1007591,212599,977538,125570,906334,995262,191472,166255,29898,973361,1024842,54375,709136,236533,150190,725411,717796,641726,216097,162675,170587,577147,831248,370500,106861,577043,943539,76459,166462,130657,477333,849153,942988,1001114,531450,809403,456210,448831,240981,768841,589543,513482,62654,778317,1010413,875249,535760,236139,563993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002258s ]