SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400571 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400571 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015317,236478,429243,896026,570794,266024,956434,911659,656612,980893,614295,279295,198975,23322,108332,476330,504754,433035,165220,7889,792271,969208,550189,393851,534959,596233,599704,523513,810551,20877,765166,922170,202943,576448,270861,977284,668709,903920,398177,149958,724401,669090,26652,996603,698269,742914,233884,416696,716203,177227,505370,343739,289656,602708,350363,669533,448256,854718,56534,143252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]