SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431222 LIMIT 1 [ RunTime:0.001412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431222 [ RunTime:0.002525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200477,988632,691598,818681,746375,317588,201337,651821,671684,238808,561147,830855,612563,45206,870468,93022,637523,407934,444097,860639,331784,923759,656795,415360,156524,697961,796956,486348,307130,201176,820109,825998,1020881,866617,973177,880267,342248,626075,861511,821402,202097,472868,47220,60093,136605,672329,856201,197409,677955,435009,119042,477677,638181,61249,821400,923479,857086,462493,360656,507728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001560s ]