SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631518 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631518 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308427,817656,119113,427189,91435,587838,106375,410795,652016,230683,247033,187485,680622,929534,415274,129597,217779,988008,723274,352306,401445,116434,710313,158593,215993,466267,745457,427097,1012380,438793,799440,143070,875212,255280,844046,420828,410526,590062,174027,214683,499877,881732,1006279,873540,266684,1010613,37145,831508,425229,355543,329189,122966,996356,587490,1045822,594569,340879,467288,125602,92883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004300s ]