SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804637 LIMIT 1 [ RunTime:0.002763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804637 [ RunTime:0.003002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739737,1044078,221362,909510,381512,391208,1038930,880347,174732,865108,414043,33279,225221,461806,350025,547245,377078,550623,401993,890463,106755,538194,408054,271066,349070,756191,342883,609365,603494,849474,923508,44470,784373,659525,294080,482129,253170,922183,286046,94814,286670,549244,910615,994993,559477,651250,921576,653591,319070,744858,580470,842383,854963,582686,375600,961013,864193,736785,387028,586613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804637 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804637 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]