SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586710 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586710 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409644,595869,97633,460353,632255,946265,939029,632358,968003,401855,561544,13176,343255,268744,714894,753497,817840,723569,806027,502434,316731,526666,303115,508501,346918,959934,258309,1017742,141422,286578,673684,526027,504455,458651,392084,742023,345114,58040,88205,223669,836072,949415,905839,82832,381011,192721,439581,1020366,647977,984647,852852,196015,204118,283606,1033542,263830,971890,595847,571410,422913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]