SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506739 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506739 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144504,880507,902421,260270,520452,294345,869922,818249,576103,417889,398896,52530,917964,319303,902513,123033,331795,423437,675767,460377,200410,146960,564008,725543,291700,107155,61034,224296,642990,495633,712155,857426,421395,624701,114336,587903,676491,764681,815801,317346,391214,427573,712957,1032398,677877,992422,725762,562574,1037998,683582,468043,323709,212525,903191,519956,91512,506900,173362,933519,124297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]