SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390099 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390099 [ RunTime:0.002521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037183,193618,463364,780650,379673,600554,676660,186898,70425,623298,350414,630528,969800,1031028,996259,201979,702217,799539,895785,1012054,76730,642932,801998,776404,783124,140131,1027620,862418,399159,474263,790633,631370,914141,408277,916172,765176,405058,614330,338801,394109,439469,893269,732922,198023,786327,688272,165212,784741,723857,389564,680928,650129,177644,222628,795459,390854,811995,271587,775815,484275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]