SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200880 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200880 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55221,682493,590211,1011569,787536,481048,793965,426091,844157,10720,674740,731342,516575,499940,590108,14172,24338,1010570,708303,1036569,953414,211136,823900,784052,315423,291301,515186,824136,827459,814867,886105,427150,937780,784107,79159,522669,182769,1011687,495543,791587,96465,63215,532368,326755,18908,344997,412172,161581,361162,441558,1046267,946906,823188,837282,866122,528028,863051,665640,221751,1004792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]