SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323673 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323673 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275933,435417,342110,91379,269985,303097,700910,714577,839543,307465,146587,505011,1008000,442091,528909,501941,830016,729699,936324,89049,951781,356836,22490,305393,506181,310319,142163,747141,451089,169673,953517,982221,1010983,735957,758648,538404,207080,225097,725092,182776,720858,442478,690977,648765,251545,8895,266840,606622,677124,220468,507114,977327,649988,322303,971712,968829,937156,174483,312692,713009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]