SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44684 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44684 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853651,758394,167974,779524,407046,84147,787839,192459,205154,291842,282135,774000,490292,983600,386594,105874,11921,110391,723985,846441,93963,1034225,149581,1048080,786275,901266,48291,765863,980775,77408,826457,161677,138770,759608,680351,259702,945273,693702,56823,477213,1018429,47705,16245,886406,179277,514396,14715,591298,90733,695800,45940,913937,221410,983045,101892,657004,812181,285722,667365,86646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]