SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040305 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040305 [ RunTime:0.002617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886320,500449,65526,240314,321117,640313,154600,224554,600188,476363,890577,459018,547501,344134,433692,703777,362588,268398,221745,490315,950066,196595,513871,510162,553365,545021,559723,82459,201701,931762,380273,755664,869945,839317,291699,941336,819215,338881,528677,716379,61089,852279,186917,851589,780213,416994,880901,775421,515192,387322,424271,364254,209782,733823,477092,873513,118835,333510,526768,882216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]