SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704813 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704813 [ RunTime:0.005996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445322,259943,973850,865077,407127,1013954,835595,179126,690499,60033,37831,680358,853585,350277,437463,468335,396867,904086,719129,710948,1012677,795705,868499,376668,968701,946572,517864,408480,640165,699742,458213,109085,276629,852626,906413,304071,944188,607070,29829,919257,145676,909936,892105,91387,21465,253891,108132,803827,922752,763577,386430,992665,788390,493968,304559,468960,130003,94536,916368,704463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]