SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491004 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491004 [ RunTime:0.003351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637053,338548,535872,910716,314057,847765,274110,885357,131679,689149,597721,697521,723728,783907,224410,860763,369812,828936,200389,647201,303634,520744,102316,241323,311329,212235,641530,841745,153037,439204,969345,445320,443069,178786,386480,423015,669811,222892,102210,314895,147908,402272,106853,594944,8953,186620,995572,797471,489827,566747,269536,561620,486939,479431,707256,41112,66241,470614,75601,63215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]