SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515140 LIMIT 1 [ RunTime:0.002343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515140 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890606,625812,732234,340081,720650,401873,208887,188660,260221,702912,98834,216397,247018,25693,294060,393974,780686,52255,266692,106231,279398,885434,436191,363977,767860,663238,972551,654580,210422,844763,746139,533225,995811,656275,698518,637645,367131,642730,479729,579125,25931,832556,636688,528856,701219,66013,697142,776731,76274,740703,942166,685613,147148,766630,24991,360126,610908,258447,386031,157352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001458s ]