SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001703s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200312 LIMIT 1 [ RunTime:0.001328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200312 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669135,174902,717466,100246,410888,889152,381090,882458,156186,662513,373952,553968,349740,1034599,196092,973202,936282,316706,598913,985415,215480,598575,773983,253337,715177,434464,327343,53210,129523,362980,950534,1000548,627560,928541,88911,917599,85274,304943,970049,304361,1034320,272172,783552,897563,151192,390188,716074,806598,115838,551311,192272,6921,96344,342555,369333,679511,244936,379922,571517,1021812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]