SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557978 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557978 [ RunTime:0.004041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320234,44126,200199,811080,933374,201141,440331,77149,474544,375854,781113,876311,2021,744087,50738,485691,638476,306428,497581,237019,712381,461579,721937,25053,1034104,870664,898055,919326,382437,607775,671966,195332,913574,729988,611961,517105,404558,326451,538150,1007682,443407,895147,431878,21342,863911,37401,377160,163553,79661,796971,440421,523468,651591,340865,549162,748653,884237,994415,729466,992460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]