SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502507 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502507 [ RunTime:0.003307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693970,259669,517075,854635,170169,767261,671500,699709,19019,922512,358499,284653,375361,938374,86280,911640,640877,267080,404194,270503,503012,672345,397111,707260,83917,27027,98072,468587,499159,295221,882715,190326,756297,196923,661825,39225,378263,781681,144330,779073,922445,896967,778955,380767,885457,731809,562225,357767,752161,81385,680589,736449,809949,863095,756678,479203,561860,857335,575662,221325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]