SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567052 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567052 [ RunTime:0.003840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712580,796241,239812,104921,340143,269447,356060,662111,1018742,65425,656324,1007024,508806,282779,341997,165299,698514,804515,688065,226679,341777,186654,1044686,202834,300979,659246,789409,601560,259888,218968,935345,660781,283224,190606,577997,70121,408642,1042128,791265,180812,809227,478251,956555,179542,697098,544476,977545,376975,306172,917487,468986,198402,872757,238122,80113,1014753,461975,350569,356357,732948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]