SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539402 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539402 [ RunTime:0.005460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300109,317518,264917,266137,210750,959374,391565,648076,167035,430324,904201,492228,813800,922379,443022,442227,16177,823510,272936,883378,662415,158276,935065,112064,502268,1037291,730600,171205,377202,828860,164360,981719,969225,881083,918573,85515,143085,749777,1007235,763904,230053,987129,202466,781258,358204,295961,857955,734885,571018,220741,228984,963238,276234,866741,530860,202704,576313,192762,378303,27823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004027s ]