SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10225 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10225 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921823,670365,151439,183577,151510,3346,748521,11723,171127,555028,17081,591115,201413,445580,419251,954306,168142,89952,74763,163861,361601,203837,908386,1000552,659304,45360,16627,420625,542808,228331,719863,809354,1035750,117119,334778,434402,996765,1041112,1022140,101931,707443,276195,783728,573037,167164,502522,483734,59700,423135,490906,717046,410571,416184,942559,267596,74236,6854,340761,211567,574208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]