SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 375151 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 375151 [ RunTime:0.003316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629711,106210,1033260,482278,118044,903901,149240,483618,765190,119315,93104,214299,939774,491634,550227,539533,386778,637201,239491,635450,245482,307772,441395,800564,655333,401059,823223,71370,1023833,353156,795296,238507,343970,1017182,999352,302285,674125,356351,310265,976663,307858,699184,239004,317368,886019,127740,737454,663699,878266,631285,914028,267478,676174,761272,611765,903544,1036591,445014,982136,680088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 375151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 375151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]