SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349801 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349801 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107147,420561,893057,766357,712974,822288,125090,96991,33922,227135,636058,824416,743989,59174,170592,811495,62916,58652,140099,860743,694163,402197,244575,1017746,108983,728911,712275,97829,987403,603908,832723,338648,358946,571381,767221,74451,135677,539836,1039408,653662,445261,355476,171775,919076,829186,791352,932825,268698,856440,290440,887892,107515,538806,804115,702650,871709,705700,959231,739171,900217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]