SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311534 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311534 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550003,239701,893382,455510,574147,740534,828774,700862,254596,692574,278769,196808,595342,425188,865606,46087,319316,211883,669602,139835,642325,278341,610836,464042,445040,1026209,171958,414019,72659,309977,983306,39694,314672,284705,176491,913598,816670,915059,342554,686196,919020,426908,859022,516761,316925,493740,942124,445002,228733,609182,961406,600384,833239,493306,180652,317810,874752,776380,528557,294498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001152s ]