SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564015 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564015 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025139,69306,552144,464771,852844,107497,871461,999690,81135,477191,530661,1005822,643882,551033,13113,10358,487714,190529,918403,227715,19631,394408,60716,195023,518457,179989,651355,924673,626588,770483,269182,692399,894163,364537,232102,464219,591528,836604,943895,318653,771918,524442,903269,771868,322913,720296,443096,409971,542905,100820,256563,401702,921408,49283,847499,996721,139868,491871,890223,834939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]