SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502513 LIMIT 1 [ RunTime:0.001261s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502513 [ RunTime:0.003778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839280,480681,624727,118172,177379,978761,143124,393064,580394,252923,515471,588046,86362,392413,423433,762655,489061,199040,388273,893152,318963,738276,74464,348138,605907,84330,399997,105037,841248,485361,415649,615561,502420,3701,340261,249299,358073,249548,235819,657807,490217,726826,936733,914332,367277,867866,921718,256182,317520,651376,291714,381980,166300,871896,288878,945067,986132,911246,275779,994512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]