SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423687 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423687 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343487,730263,677523,903102,612339,989805,589320,248127,710325,318657,583584,887020,597218,486791,280181,218741,358636,1021686,769977,930939,518356,774214,196946,162042,821776,322518,4525,220069,729416,728627,519137,887812,552433,40745,331266,266927,368482,234999,259422,842185,167247,788040,833079,492256,604957,827250,156662,462872,40805,585123,106221,72541,442227,625249,367152,750424,540191,257183,630121,647300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001287s ]