SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343980 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343980 [ RunTime:0.002201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667431,844582,546516,30568,75494,991225,415237,500657,559117,581528,187792,24464,1031401,998415,584512,973189,347838,756524,831759,111518,343418,811865,642219,428742,180,834140,27885,282497,488611,685882,905418,853901,1016252,618375,217628,297070,1032724,73586,705404,316667,191357,162237,1026831,539461,520231,766282,916666,674276,953878,100156,1020753,6414,918254,224558,64371,436856,303595,111759,628930,618216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]