SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515254 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515254 [ RunTime:0.002964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011920,738292,56313,665599,165742,874454,461623,81236,695314,540878,166510,557307,334602,187274,601080,435316,418778,176512,553291,13433,494359,521976,373899,858017,30106,521977,1007636,591409,560638,980725,407597,166745,919952,865050,195426,226601,649254,238608,23851,512337,601295,451200,363104,430764,487819,817887,187515,439075,1021049,189069,900593,94546,563264,650362,1022690,433256,809626,1024600,929489,787524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]