SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553398 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553398 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456295,15457,133624,226499,1042767,989404,494042,77371,512442,509015,361991,575969,290147,423764,353011,119999,278670,527558,877575,178138,801916,137069,49123,98145,1022986,1001332,901271,935142,389988,135992,877455,844884,575581,371276,933522,603395,996447,584640,1046743,597185,119691,733283,35598,234512,281563,945435,14782,730450,4540,636173,259165,1017293,334924,786906,160683,657373,464703,332182,1031050,250424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]