SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000688 LIMIT 1 [ RunTime:0.000654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000688 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830991,107166,392374,878024,724667,271747,735853,739480,450682,202313,646529,810973,361939,214858,946293,111518,250058,577598,788724,925728,372786,428074,1017015,502001,788515,210200,104567,830293,545401,994375,232475,353983,277743,122905,248021,953471,319802,370706,17691,76807,43533,18782,238791,853689,478859,639380,519950,214567,555350,504789,487875,666732,209997,205784,191421,323239,745745,571917,969429,873336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001629s ]