SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510985 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510985 [ RunTime:0.003623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111161,776110,747293,239790,623591,832959,825856,966771,172756,362288,184937,514417,562275,772335,278606,413323,499121,373434,542929,941827,541569,431228,335070,578224,106683,913637,696890,447120,712472,878209,491573,10633,477748,723355,250292,163363,34889,82895,249304,825067,722862,609053,557107,686082,1035789,281214,786473,114859,383692,497963,250068,229772,145445,708096,430443,909521,115003,561543,824660,769056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]