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` = 504911 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504911 [ RunTime:0.003298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911236,533538,607105,1005327,134517,141610,952008,467631,1039139,834715,554651,456376,507694,860550,489854,638726,96451,129917,136208,219384,821455,315863,619898,762122,368715,512085,980029,71148,368308,280188,181114,929742,917255,543526,558468,587686,598509,892816,176583,349534,871961,501040,973933,324509,701920,499879,741644,698425,264037,899403,77977,594797,735659,902573,53956,241192,35525,51167,604262,1026240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]