SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001705s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438488 LIMIT 1 [ RunTime:0.002194s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438488 [ RunTime:0.006852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788804,485230,570403,384814,179604,1040392,1044394,26053,900195,719577,800776,58715,358693,992373,745278,679197,961521,444617,182010,157580,544649,156260,890206,192842,1017864,152171,654880,304385,398281,33527,326982,135042,922939,235370,395124,707094,371091,762931,508605,1003823,849154,607760,171086,564830,79014,704610,197225,555090,710533,478235,114836,519163,22329,474610,446019,483849,296925,365331,1010648,250993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002273s ]