SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 64009 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 64009 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473532,23764,600041,534013,479260,106121,449357,1041155,666876,29132,250168,374908,457978,297228,648062,462350,818117,968610,715312,206950,281049,985960,894560,28313,196542,1023625,367044,355313,696967,613834,52204,933933,1008057,746501,152636,329285,867934,1026689,369512,97315,921315,560130,200900,735771,878476,887309,727875,291886,627698,322920,1037481,571491,292890,874555,590218,1009615,664591,843177,85845,154322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 64009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 64009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]