SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201822 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201822 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010441,274329,458696,164915,588310,497297,450064,631781,289775,70119,184214,155139,877701,293110,286805,929772,1028819,85735,309090,12767,1004666,412126,878967,360541,296522,987851,609567,447336,834701,710764,507135,970849,54105,240928,996627,1007671,4183,590729,100473,355270,324396,293942,40730,353033,380154,406993,844531,121678,716197,488775,119321,388826,224103,212558,568392,1012336,1001486,127759,876755,558936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000853s ]