SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410522 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410522 [ RunTime:0.003546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814108,15919,83011,463580,381003,491837,776974,1013327,937132,990192,120323,866468,243609,358710,701449,363523,100098,420793,307888,708619,198283,610905,736557,672686,219532,654876,692749,546882,592617,918414,383974,630400,1031473,70836,227177,873722,98682,551517,201640,297961,512221,403543,510290,187076,22102,687084,1041030,719400,274901,453914,213533,695529,492930,358592,556543,916523,635774,685530,598139,347000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]