SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671746 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671746 [ RunTime:0.002676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100719,854159,513812,542228,634798,349728,345164,344696,862224,724196,705403,610727,41661,979123,452345,732193,281996,836292,101050,994930,1006263,245416,346772,424731,821070,153319,659872,253291,279848,793748,442185,507493,109709,987995,818180,415901,523194,740630,454189,825500,908959,250785,851841,561601,97492,800251,395097,964548,1036288,10155,811985,141224,359153,1011256,557740,666719,600402,361259,313924,1037030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]