SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535772 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535772 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152933,32202,827624,585384,517527,358401,730752,375819,955758,522486,811512,970849,454853,855408,475070,750587,738914,369251,176604,407341,543544,781398,792904,561260,559990,690182,390851,979127,144460,859918,928922,70164,914799,275792,565605,771247,310897,287026,264070,935351,237240,971737,855399,1021922,186207,61925,635823,772481,65048,310010,256154,531449,1036598,786436,546104,819818,929732,1002011,49045,517639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535772 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535772 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000907s ]