SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022107 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022107 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524688,1019650,534343,415067,924795,110428,111837,889747,461858,1040677,411232,117715,971719,278075,326319,910136,969607,146635,505821,120361,429498,423975,244436,198896,698944,726282,196901,603023,507923,941801,414402,976889,931655,679312,312494,77805,991590,925066,162766,944502,132547,867140,1030930,192568,212919,334058,749364,1012606,182499,758444,889383,808902,748474,353855,409119,62246,916013,611861,509269,619614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]