SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806710 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806710 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235384,737559,986102,106174,972051,242205,100583,552950,766162,477496,1011822,65527,584794,438019,117134,137976,768273,776028,536539,470756,890362,759847,695561,600168,430567,102848,32259,60166,342253,193025,93777,500469,719903,762297,373536,1007144,876403,122244,37380,869007,236029,348529,636708,154264,330632,452322,640986,123228,799814,671294,590246,660584,343349,321607,167609,710679,481211,691984,383541,185627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]