SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415881 LIMIT 1 [ RunTime:0.001323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415881 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135188,507393,202916,207230,916468,794966,924562,284656,450329,943530,604504,611879,23032,1014310,13379,416421,874665,954882,189739,92133,482282,205846,775992,905510,49761,560265,75521,595820,376153,51227,727344,844358,47226,532655,46526,739347,321188,432833,428375,66344,24401,755550,928429,454558,440609,401951,965970,317887,91815,150475,862853,368357,272151,470028,386781,939888,104972,19976,829252,716420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]