SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40561 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40561 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663082,534297,906480,739612,440799,704561,1013780,661066,415479,852056,465161,261875,602719,742110,992688,559926,172719,237835,375484,470503,621441,903911,809966,232653,254464,133163,322288,151824,646835,816283,655110,160060,1046676,191812,125121,669123,436973,990718,16317,442433,1014748,592455,222344,579298,227878,116852,822037,540403,310885,771362,906266,556751,244462,921794,78077,316559,65087,650543,752497,473102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]