SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149191 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149191 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408912,93017,276629,988252,518571,604432,915778,938494,545639,865486,666377,228319,56594,333584,353328,960028,969969,348384,1042036,270758,980804,642260,922836,381637,1010981,517763,612275,842672,543912,378933,560357,286123,360327,497642,874620,955873,441182,172233,992315,196344,809720,531002,259112,113104,927533,729977,441331,78509,922240,839550,999909,281717,391486,890733,313392,602680,526912,41307,498723,740984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002301s ]