SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418522 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418522 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983933,402186,1048031,413626,804212,465993,222348,906882,759051,39441,885935,74542,77688,553554,231963,829719,391752,826412,89072,138325,460428,645024,1023711,190480,580408,519730,741982,555639,104844,550050,623216,343957,369477,316452,21020,438232,844517,804561,943668,693025,285139,14123,571919,607921,674310,750890,73501,10970,798852,419359,1016412,662838,253712,352221,265151,205190,447974,302675,570486,365881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]