SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 714841 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 714841 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420862,767025,539815,215202,369202,548475,1040598,10771,984132,553332,126209,223968,544744,1028073,158318,848802,710171,795632,548392,795036,992161,214565,959156,201822,861679,610010,213772,301010,401169,1034521,330941,210566,646536,965702,286724,641934,275064,872835,607313,300430,118355,1000623,356384,123546,63719,933231,928288,51821,392520,407002,942747,389887,772658,224672,230083,247096,46296,730100,337874,1011775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 714841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 714841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]