SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046991 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046991 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400877,908148,440169,373423,547736,803427,698457,971426,188335,498247,649853,556889,943825,650414,433011,262327,696731,400693,809841,681905,147013,766516,660580,605062,837592,961226,581425,357619,49243,481250,787924,870292,852429,218454,853922,442340,193455,603807,250983,559807,1026718,860511,174127,372869,1041268,181785,861143,689151,894546,61958,1011473,170724,977328,809581,835849,587326,600260,903513,644634,429205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]