SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322106 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322106 [ RunTime:0.005498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419781,661719,697492,176997,81506,402819,742049,66267,39761,970606,678334,536814,577524,73654,1014780,264247,636577,27679,308566,433101,622117,944636,530925,15354,517238,343730,770236,506240,125952,209496,704113,510497,47738,680678,1041677,92147,800660,733046,723075,507699,76988,650290,556462,824382,528655,121457,303009,481564,564825,149734,511270,184673,625410,843956,779316,304733,237309,552192,147842,939235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]