SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422005 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422005 [ RunTime:0.002718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540185,823708,664608,835042,196497,29353,241588,1006995,542615,91362,346357,538649,68304,190324,969401,127586,848497,256687,1966,506376,874091,139721,842388,72265,919058,231962,414838,268173,1949,89686,350329,66110,693735,37917,71584,815725,329136,651423,654760,374181,219262,686636,337884,698983,842988,895043,884376,394373,179492,116314,660110,123384,902400,685511,842875,836118,398357,725702,984541,839173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]