SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241012 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241012 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302080,342875,372009,7219,570334,375337,460630,33973,774100,639784,774634,496595,579161,610254,766427,592040,907847,388944,780244,506103,510143,367925,429760,657105,405127,272077,553118,1039053,381055,877484,138615,814551,356243,691571,766285,535135,430057,280524,980681,767792,998888,807331,965944,961312,55480,551440,160617,1047385,354077,33885,735269,791520,463516,582731,927928,184889,45599,53994,631874,445448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003768s ]