SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393595 LIMIT 1 [ RunTime:0.000908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393595 [ RunTime:0.003948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594473,20722,67243,206619,123644,556832,139546,994664,34686,642858,324871,115088,737390,391788,482831,162250,861341,325002,818963,91997,400461,180414,621779,188245,205063,145010,241059,108452,723584,465955,825347,721976,953210,1013937,141311,627319,1028463,1044515,439237,158159,887598,168009,398908,493798,658257,881002,505168,877443,1045116,877011,280890,334032,104607,105786,234231,475616,616323,303062,408591,424151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002607s ]